package com.xingzhe.pengji.security.sql.common;

/**
 * @Title ： 三江学院 毕业设计
 * @Description ：
 * @author ：LuFengLiang
 * @Company: IT行者工作室
 * @Copyright: Copyright (c) 2012-2-24
 * @version ： 1.0
 */
public interface SqlColumnsUtil
{

    String STATIC_WHERE = (new StringBuilder()).append(SqlKeyWord.KeyWord.WHERE.getValue())
            .append(SqlKeyWord.KeyWord.SPACE.getValue()).append("1").append(SqlKeyWord.Relationship.EQUAL.getValue())
            .append("1").append(SqlKeyWord.KeyWord.SPACE.getValue()).toString();

    String USER_COMMON_COLUMNS = "id,account,name,password,email,enabled,is_sys,account_non_expired,account_non_locked,credentials_non_expired,creator,create_time,update_man, update_time, del_flag";

    String GROUP_COMMON_COLUMNS = "id,name,description,enabled,creator,create_time,update_man, update_time, del_flag";

    String AUTHORITE_COMMON_COLUMNS = "id,name,description,enabled,creator,create_time,update_man, update_time, del_flag";

    String RESOURCE_COMMON_COLUMNS = "id,name,description,enabled,url,priority,type,creator,create_time,update_man, update_time, del_flag";

    String USER_UPDATE_TOP_SQL = SqlFactory.createUpdateSql("USER");

    String GROUR_UPDATE_TOP_SQL = SqlFactory.createUpdateSql("GROUP");

    String AUTHORITE_UPDATE_TOP_SQL = SqlFactory.createUpdateSql("AUTHORITE");

    String RESOURCE_UPDATE_TOP_SQL = SqlFactory.createUpdateSql("RESOURCE");

}
